package com.atguigu.edu.realtime.util;

public class MysqlUtil {

    public static String mysqlLookUpTableDDL(String tableName) {

        String ddl = "WITH (" +
                "'connector' = 'jdbc'," +
                "'url' = 'jdbc:mysql://hadoop101:3306/edu'," +
                "'table-name' = '" + tableName + "'," +
                "'lookup.cache.max-rows' = '500'," +
                "'lookup.cache.ttl' = '1 hour'," +
                "'username' = 'root'," +
                "'password' = 'wuzu-3realtime'," +
                "'driver' = 'com.mysql.cj.jdbc.Driver'" +
                ")";
        return ddl;
    }

}
